﻿SELECT
	[main].object_id AS [ObjectId],
	[main].[name] AS [ObjectName],
	[schema].[name] AS [SchemaName],
	[main].[base_object_name] AS [BaseObjectName]
FROM sys.synonyms [main]
INNER JOIN sys.schemas [schema] ON [main].[schema_id] = [schema].[schema_id]
WHERE
	1 = 1
-- [WHERECLAUSE]
